Upgrade Utility Changes

12.1.0.0 to 12.2.0.0

  • Added new tables to capture requirement history: ASREQUIREMENTHISTORY, ASREQUIREMENTHISTORYDETAIL, and ASREQUIREMENTCHILD.

  • Added a new table for REST API error logging: ASRESTSERVICEERRORS.

  • Added a new table for OIDC user sessions: ASOIDCUSERSESSIONS.

  • Added a new table for rule schema storage: ASRULESCHEMA.

  • Added the COMPANYGUID column to ASCLIENT.

  • Added the UPDATESOURCE column to ASREQUIREMENTHISTORY, ASHISTORY, ASPHONEHISTORY, and ASWORKFLOWHISTORY.

  • Added the NONPROPORTIONALREDUCTION column to ASPLANFUND.

  • Added the XMLDATA and ENTITYTYPE columns to ASCHECKINCHECKOUT.

  • Expanded ASPLAN.PLANNAME to a length of 150.

  • Expanded SQL Server ASPOLICY.POLICYNUMBER to NVARCHAR(60).

  • Changed SQL Server ASINTAKERECORD.RECORDXML from NTEXT to VARCHAR(MAX).

  • Changed SQL Server ASACTIVITYSEQUENCETASK.ERRORXML from NTEXT to VARCHAR(MAX).

  • Added authorization tables for future enhancements: ASAUTHAIAGENT, ASAUTHCOMPANYAIAGENT, and ASAUTHPLANAIAGENT.

12.0.x to 12.1.0.0

  • Adding new entries to ASRESTCHEMA to enable CRUD functionality for selected entities in the service layer.

  • Adding the PLANSLICEGUID column to the ASPLANFUND table.

  • Introduced new tables: ASBILLFIELD, ASPHONEHISTORY, and ASPHONEHISTORYDETAIL.

  • Implemented multiple schema updates across the database, including modifications to tables, columns, indexes, constraints, and data adjustments.

11.3.1.0 to 12.0.x

  • Upgrade Utility tool Java Version: 17.0.x.

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

  • From this version (v12) of Upgrade Utility, tools also takes care of insertion of REST API schema and predefined data into OIPA database. No separate scripts will be provided. Earlier these table scripts were delivered as part of separate migrate scripts.

  • Unused column SubStatusCode column in AsActivity table has been renamed as ArchivalStatusCode. This column will be utilized in future for tracking status of archival process on entities at multiple stages.

11.3.0.1 to 11.3.1.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.3.0.0 to 11.3.0.1

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.2.0.0 to 11.3.0.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes which also include below

  • MultiFieldModule

    • Update the existing MultiValueField tables with the new schema.

    • Update existing MultiField rules to ensure a Name element exists.

  • BusinessRuleModule

    • Convert the existing rules and definitions into JSON schema.

  • SegmentNameJsonSchemaModule

    • Convert the definitions of all the segments into JSON schema.

  • RequirementJsonSchemaModule

    • Convert the definitions of all the requirements into JSON schema

  • WriteValuationElementsModule

    • Replace NetGain as BeginNetGain and EndNetGain.

    • Remove SurrenderValue and FreeAmount as an "Available Element" under Fund.

    • Remove SurrenderRate and SurrenderValue under Deposit.

11.2.0.0 to 11.2.1.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.1.0.0 to 11.2.0.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.0.2.0 to 11.1.0.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.0.1.0 to 11.0.2.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

11.0.0.0 to 11.0.1.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes.

10.2.2.0 to 11.0.0.0

A variety of schema updates are required for this release including table, column, index, constraint and data changes.

10.2.0.0 to 10.2.2.0

  • A variety of schema updates are required for this release including table, column, index, constraint and data changes which also include below.

  • PlanOrderToProductPlanOrderModule

    • Added to change the existing rule 'PlanOrder' to 'ProductPlanOrder'.

  • GroupCustomerHistoryUpdateModule

    • Updates the RelatedGuid to GroupCustomerGuid instead of ClientGuid in AsHistory table for Group Customers.